﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>database</title>
    <style type="text/css">
        body
        {
            font-size: 9pt;
        }
        .styledb
        {
            font-size: 14px;
        }
        .styletab
        {
            font-size: 14px;
             padding-top:15px;             
        }
		table{
			border-color: #eee;
		}
		td{
			border-color: #eee;
		}
    </style>
</head>
<body>
    <div style="text-align: center">
     <h1 class="">数据库CommonAdminCore表结构说明文档<a name="index"></a></h1><div style="width:80%;margin:50px auto;"><div style="margin:50px 0;"><table  border="0" cellpadding="5" cellspacing="0" width="100%"><tr><td bgcolor="#FBFBFB"><table cellspacing="0" cellpadding="5" border="1" width="100%" bordercolorlight="#D7D7E5" bordercolordark="#D3D8E0"><tr bgcolor="#F0F0F0"><th colspan="2">序号</th>
<th colspan="4">表名</th>
<th colspan="5">说明</th>
</tr><tr>
<td  colspan="2">1</td><td  colspan="4"><a href="#TH_Invoice">TH_Invoice<a/></td><td  colspan="5">发票信息</td></tr>
<tr>
<td  colspan="2">2</td><td  colspan="4"><a href="#TH_InvoiceDetail">TH_InvoiceDetail<a/></td><td  colspan="5">发票明细信息</td></tr>
</table></td></tr></table></div><div style="margin:50px 0;"><table  border="0" cellpadding="5" cellspacing="0" width="100%"><tr>
<td class="title" colspan="11"><span style="float:left;">TH_Invoice:发票信息<a name="TH_Invoice"><a/></span> <a style="float:right;" href="#index">返回目录</a></td></tr>
<tr><td bgcolor="#FBFBFB"><table cellspacing="0" cellpadding="5" border="1" width="100%" bordercolorlight="#D7D7E5" bordercolordark="#D3D8E0"><tr bgcolor="#F0F0F0"><td>序号</td><td>列名</td><td>数据类型</td><td>长度</td><td>小数位</td><td>自增标识</td><td>主键</td><td>外键</td><td>允许空</td><td>默认值</td><td>说明</td></tr><tr><td>1</td><td>Id</td><td>int</td><td>4</td><td>0</td><td>是</td><td>是</td><td>&nbsp;</td><td>否</td><td>&nbsp;</td><td align="left" >记录序号</td></tr><tr><td>2</td><td>InvoiceID</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票ID</td></tr><tr><td>3</td><td>InvoiceKind</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票类型(红票)</td></tr><tr><td>4</td><td>InvoiceCode</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>否</td><td>&nbsp;</td><td align="left" >发票代码</td></tr><tr><td>5</td><td>InvoiceNo</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>否</td><td>&nbsp;</td><td align="left" >发票号</td></tr><tr><td>6</td><td>InvoiceDate</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票日期</td></tr><tr><td>7</td><td>BuyerCode</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >购方税号</td></tr><tr><td>8</td><td>BuyerName</td><td>varchar</td><td>200</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >购方名称</td></tr><tr><td>9</td><td>BuyerAddress</td><td>varchar</td><td>400</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >购方地址</td></tr><tr><td>10</td><td>BuyerTel</td><td>varchar</td><td>200</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >购方电话</td></tr><tr><td>11</td><td>BuyerBankAccount</td><td>varchar</td><td>400</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >购方银行账户</td></tr><tr><td>12</td><td>SalerCode</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >销方税号</td></tr><tr><td>13</td><td>SalerName</td><td>varchar</td><td>200</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >销方名称</td></tr><tr><td>14</td><td>SalerAddress</td><td>varchar</td><td>400</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >销方地址</td></tr><tr><td>15</td><td>SalerTel</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >销方电话</td></tr><tr><td>16</td><td>SalerBankAccount</td><td>varchar</td><td>200</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >销方银行账户</td></tr><tr><td>17</td><td>SalerBank</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >销方银行开户行</td></tr><tr><td>18</td><td>MachineCode</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >机器码</td></tr><tr><td>19</td><td>CheckCode</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >校验码</td></tr><tr><td>20</td><td>Ciphertext</td><td>varchar</td><td>2000</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票密文</td></tr><tr><td>21</td><td>QrCode</td><td>varchar</td><td>2000</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >二维码</td></tr><tr><td>22</td><td>Money</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >含税金额</td></tr><tr><td>23</td><td>Tax</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >税额</td></tr><tr><td>24</td><td>MoneyTaxNone</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >无税金额</td></tr><tr><td>25</td><td>InvoiceRemark</td><td>varchar</td><td>1000</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >备注</td></tr><tr><td>26</td><td>CreateName</td><td>varchar</td><td>40</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >开票人</td></tr><tr><td>27</td><td>CheckName</td><td>varchar</td><td>40</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >复核人</td></tr><tr><td>28</td><td>PayeeName</td><td>varchar</td><td>40</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >收款人</td></tr><tr><td>29</td><td>InvoiceImage</td><td>varchar</td><td>500</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>30</td><td>InvoicePdf</td><td>varchar</td><td>500</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>31</td><td>Status</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票状态</td></tr><tr><td>32</td><td>RedByInvoiceCode</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >冲红原票代码</td></tr><tr><td>33</td><td>RedByInvoiceNo</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >冲红原票号码</td></tr><tr><td>34</td><td>RedConfirmNo</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >红票确认单号</td></tr><tr><td>35</td><td>CheckMoney</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >核对金额</td></tr><tr><td>36</td><td>CheckStatus</td><td>varchar</td><td>20</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >核对状态</td></tr><tr><td>37</td><td>CheckAmount</td><td>int</td><td>4</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >核对明细数</td></tr><tr><td>38</td><td>SettleMoney</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >结算金额</td></tr><tr><td>39</td><td>UpdateTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >更新时间</td></tr><tr><td>40</td><td>CheckTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>41</td><td>SettleStatus</td><td>varchar</td><td>20</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >结算状态</td></tr><tr><td>42</td><td>SettleTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >结算时间</td></tr><tr><td>43</td><td>CreatorTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>44</td><td>CreatorUserId</td><td>bigint</td><td>8</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>45</td><td>CreateOrgId</td><td>bigint</td><td>8</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>46</td><td>LastModifyTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>47</td><td>LastModifyUserId</td><td>bigint</td><td>8</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>48</td><td>DeleteMark</td><td>bit</td><td>1</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>49</td><td>DeleteTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>50</td><td>DeleteUserId</td><td>bigint</td><td>8</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>51</td><td>TenantId</td><td>bigint</td><td>8</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr></table></td></tr></table></div><div style="margin:50px 0;"><table  border="0" cellpadding="5" cellspacing="0" width="100%"><tr>
<td class="title" colspan="11"><span style="float:left;">TH_InvoiceDetail:发票明细信息<a name="TH_InvoiceDetail"><a/></span> <a style="float:right;" href="#index">返回目录</a></td></tr>
<tr><td bgcolor="#FBFBFB"><table cellspacing="0" cellpadding="5" border="1" width="100%" bordercolorlight="#D7D7E5" bordercolordark="#D3D8E0"><tr bgcolor="#F0F0F0"><td>序号</td><td>列名</td><td>数据类型</td><td>长度</td><td>小数位</td><td>自增标识</td><td>主键</td><td>外键</td><td>允许空</td><td>默认值</td><td>说明</td></tr><tr><td>1</td><td>Id</td><td>int</td><td>4</td><td>0</td><td>是</td><td>是</td><td>&nbsp;</td><td>否</td><td>&nbsp;</td><td align="left" >记录序号</td></tr><tr><td>2</td><td>InvoiceID</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票ID</td></tr><tr><td>3</td><td>InvoiceCode</td><td>varchar</td><td>20</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票代码</td></tr><tr><td>4</td><td>InvoiceNo</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票号</td></tr><tr><td>5</td><td>InvoiceRowNumber</td><td>int</td><td>4</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >发票行号</td></tr><tr><td>6</td><td>GoodsName</td><td>varchar</td><td>200</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >商品名称</td></tr><tr><td>7</td><td>GoodsSpec</td><td>varchar</td><td>200</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >规格</td></tr><tr><td>8</td><td>GoodsUnit</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >单位</td></tr><tr><td>9</td><td>GoodsAmount</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >数量</td></tr><tr><td>10</td><td>GoodsPrice</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >单价</td></tr><tr><td>11</td><td>GoodsTaxRate</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >税率</td></tr><tr><td>12</td><td>GoodsTax</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >税额</td></tr><tr><td>13</td><td>GoodsMoney</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >金额</td></tr><tr><td>14</td><td>GoodsMoneyNoTax</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >无税金额</td></tr><tr><td>15</td><td>GoodsCode</td><td>varchar</td><td>20</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >商品税号</td></tr><tr><td>16</td><td>GoodsKind</td><td>varchar</td><td>100</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >商品分类</td></tr><tr><td>17</td><td>CheckMoney</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >核对金额</td></tr><tr><td>18</td><td>CheckStatus</td><td>varchar</td><td>20</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >核对状态</td></tr><tr><td>19</td><td>IsCheckEnd</td><td>int</td><td>4</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >是否核对结束</td></tr><tr><td>20</td><td>CheckTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >核对时间</td></tr><tr><td>21</td><td>UpdateTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >更新时间</td></tr><tr><td>22</td><td>SettleStatus</td><td>varchar</td><td>50</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>23</td><td>SettleMoney</td><td>decimal</td><td>9</td><td>2</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>24</td><td>SettleTime</td><td>datetime</td><td>8</td><td>3</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr><tr><td>25</td><td>IsJicai</td><td>int</td><td>4</td><td>0</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>是</td><td>&nbsp;</td><td align="left" >&nbsp;</td></tr></table></td></tr></table></div></div>   
    </div>
</body>
</html>
